Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


PreviousPrevious NextNext

~Tanita Chugerobergflar 28.Jan.04 02:28 AM a Web browser
Notes Client 6.5 Windows 2000


I have a field within a form that is a DialogList Type field. This field uses formula to obtain the choices. The formula is:

SRepID:=@GetProfileField ("DBProfile"; "SouvDBRepID") ;
view := "BDKeywords";
column := 2;

tmpDbLookup := @DbLookup ("":"NoCache"; SRepID; view; CompanyType; column);

@If (tmpDbLookup != ""; tmpDbLookup; "No Client names available. See administrator.")

This code, as means of an explanation, looks up the SOUVENIR Database (a Contact Database), using a categorised view ("BDKeywords") based on the CompanyType. The values being "Client", "Construction", "Consultant", and "Operator". Within the SOUVENIR database there could be multiple contacts associated to a Company within a category. I am trying to retrieve the Company Name for this field. However, the DbLookup is returning multiple entries for a company where there are multiple contacts. That is, the company Bovis Lend Lease has four contacts associated with the company in the SOUVENIR Database. The DbLookup returns all four entries.

I have used @Unique (tmpDbLookup) and @Unique (@DbLookup (xxx) where xxx = required parameters) with no success.

The odd thing is that there is an entry of a company with two contacts under the category of "Client" and the lookup retrieves only one. However, this is not the case for "Construction", "Consultant", "Operator" where there are multiple contacts for a company.

Can anyone suggest a possible solution, thank you.

Barry Eddy

  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS